IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spPressreleasesUpdateMessage]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[spPressreleasesUpdateMessage]
GO
-- =============================================
-- Author:		Nam Tran
-- Create date: Sep 21, 2014
-- Description:	Update prMessage
-- =============================================
CREATE PROCEDURE [dbo].[spPressreleasesUpdateMessage]
	@Id		BIGINT,
	@Message	NVARCHAR(MAX)
AS
BEGIN
	SET NOCOUNT ON;

	UPDATE	Pressreleases 
	SET		Message = @Message 
	WHERE	Id = @Id
END